I have a DBF (FoxPro) table with dates displayed as dd/mm/yyyy. The values are stored as yyyymmdd e.g. 20070312. When I open the file in Excel 2007, the dates are transcribed into US format (03/12/2007) - it should read 12/03/2007 as my locale is UK.
For a date where the dd values are greater than 12 i.e. 20070313, the date conversion fails and the value in the cell is shown as text 20070313.
There is nothing I can do in Excel (other than create a macro) to present the dates correctly - it appears that the DBF driver used by Excel only reads dates in US format.
Does anyone have a solution for this problem which does not involve a macro in Excel?
TIA
dai50
Bookmarks